SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_AddRecruitmentParticipants_apply]

	(
	@param_recruitment int,
	@param_employing_unit int,
	@param_booth_quantity Int,
	@param_booth_arrange NVarChar(MAX),
	@param_remark_recruitment NVarChar(MAX),
	@param_contactperson NVarChar(50),
	@param_mobile NVarChar(50),
	@param_email NVarChar(50),
	@param_phone NVarChar(50),
	@param_fax NVarChar(50),
	@param_is_payment Bit,
	@param_is_need_invoice Bit,
	@param_invoice_beginning NVarChar(50),
	@param_invoice_item NVarChar(50),
	@param_add_time smalldatetime,
	@param_user_add NVarChar(50),
	@param_state Bit,
	@param_user_check NVarChar(50),
	@param_remark_invoice NVarChar(50),
	@param_is_visible bit
	)

AS
	/* SET NOCOUNT ON */
	insert into dbo.JOL_Recruitment_Participants_apply
	(
	 recruitment,
	 employing_unit,
	 booth_quantity,
	 booth_arrange ,
	 remark_recruitment ,
	 contactperson ,
	 mobile ,
	 email ,
	 phone,
	 fax,
	 is_payment,
	 is_need_invoice,
	 invoice_beginning ,
	 invoice_item,
	 add_time ,
	 user_add ,
	 state,
	 user_check,
	 remark_invoice,
	 is_visible
	
	)
	values
	(
	@param_recruitment,
	@param_employing_unit,
	@param_booth_quantity,
	@param_booth_arrange ,
	@param_remark_recruitment ,
	@param_contactperson ,
	@param_mobile ,
	@param_email ,
	@param_phone,
	@param_fax,
	@param_is_payment,
	@param_is_need_invoice,
	@param_invoice_beginning ,
	@param_invoice_item,
	@param_add_time ,
	@param_user_add ,
	@param_state,
	@param_user_check,
	@param_remark_invoice,
	@param_is_visible
	)
	
	RETURN

GO
